import sqlite3
bd=sqlite3.connect('magasin.db')
curseur=bd.cursor()

curseur.executescript('''
    CREATE TABLE Fournisseur(NumFour INT(5), Nom VARCHAR(30),
    	PRIMARY KEY(NumFour));
    CREATE TABLE FournisseurBis(NumFour INT(5), Nom VARCHAR(30),
    	PRIMARY KEY(NumFour));
    CREATE TABLE Client(NumClient INT(5), Nom VARCHAR(30), Prenom VARCHAR(20),
    	DateNaissance DATE, CodePostal VARCHAR(5), Ville VARCHAR(30),
    	PRIMARY KEY(NumClient));
    CREATE TABLE Produit(NumProduit INT(5), Nom VARCHAR(30), Prix FLOAT,
    	NumFour INT(5) REFERENCES Fournisseur(NumFour),
    	PRIMARY KEY(NumProduit));
    CREATE TABLE Commande(NumClient INT(5) REFERENCES Client(NumClient),
    	NumProduit INT(5) REFERENCES Produit(NumProduit), Date DATE,
    	Quantite INT(5), PRIMARY KEY(NumClient, NumProduit, Date));
''')

curseur.executescript('''
INSERT INTO Client VALUES(1, 'Fourcade', 'Martin', '1988-09-14', '38250', 'Villard-de-Lans');
INSERT INTO Client VALUES(2, 'Tardivel', 'Pierre', '1963-11-26', '74000', 'Annecy');
INSERT INTO Client VALUES(3, 'Manaudou', 'Florent', '1990-11-12', '13000', 'Marseille');
INSERT INTO Client VALUES(4, 'Pinturault', 'Alexis', '1991-03-20', '73600', 'Moûtiers');
INSERT INTO Client VALUES(5, 'Laffont', 'Perrine', '1998-10-28', '09300', 'Lavelanet');
INSERT INTO Client VALUES(6, 'Vaultier', 'Pierre', '1987-06-24', '05100', 'Briançon');
INSERT INTO Client VALUES(7, 'Gibert', 'Fanny', '1993-02-16', '34000', 'Montpellier');
INSERT INTO Client VALUES(8, 'Braisaz-Bouchet', 'Justine', '1996-07-04', '73200', 'Albertville');
INSERT INTO Client VALUES(9, 'Noël', 'Clément', '1997-05-03', '88200', 'Remiremont');

INSERT INTO Produit VALUES(1, 'Lunettes Cobra', 32 , 1);
INSERT INTO Produit VALUES(2, 'Boots de snowboard Synapse', 330, 3);
INSERT INTO Produit VALUES(3, 'Piolet Monte Bianco', 144, 2);
INSERT INTO Produit VALUES(4, 'Skis de piste M Free 118', 640, 5);
INSERT INTO Produit VALUES(5, 'Skis de fond X-IUM Skating', 460, 4);
INSERT INTO Produit VALUES(6, 'Maillot de bain Powerskin', 259, 1);
INSERT INTO Produit VALUES(7, 'Casque Sirocco', 84, 8);
INSERT INTO Produit VALUES(8, 'Mousqueton Goliath', 9, 7);
INSERT INTO Produit VALUES(9, 'Corde Diablo', 158, 6);
INSERT INTO Produit VALUES(10, 'Skis de piste 4x4 563', 550, 5);

INSERT INTO Fournisseur VALUES(1, 'Arena');
INSERT INTO Fournisseur VALUES(2, 'Grivel');
INSERT INTO Fournisseur VALUES(3, 'Salomon');
INSERT INTO Fournisseur VALUES(4, 'Rossignol');
INSERT INTO Fournisseur VALUES(5, 'Dynastar');
INSERT INTO Fournisseur VALUES(6, 'Béal');
INSERT INTO Fournisseur VALUES(7, 'Simond');
INSERT INTO Fournisseur VALUES(8, 'Petzl');
INSERT INTO FournisseurBis VALUES(1, 'Arena');
INSERT INTO FournisseurBis VALUES(2, 'Speedo');
INSERT INTO FournisseurBis VALUES(3, 'Salomon');

INSERT INTO Commande VALUES(2, 8, '2026-11-24', 30);
INSERT INTO Commande VALUES(6, 2, '2026-10-08', 6);
INSERT INTO Commande VALUES(7, 7, '2026-12-04', 2);
INSERT INTO Commande VALUES(1, 5, '2026-11-20', 5);
INSERT INTO Commande VALUES(5, 5, '2026-10-28', 2);
INSERT INTO Commande VALUES(4, 10, '2026-06-13', 6);
INSERT INTO Commande VALUES(3, 1, '2026-06-13', 6);
INSERT INTO Commande VALUES(5, 4, '2026-09-16', 5);
INSERT INTO Commande VALUES(3, 6, '2026-04-12', 8);
INSERT INTO Commande VALUES(2, 3, '2026-05-20', 2);
INSERT INTO Commande VALUES(7, 9, '2026-05-20', 4);
INSERT INTO Commande VALUES(4, 8, '2026-05-11', 4);
INSERT INTO Commande VALUES(9, 8, '2026-07-18', 1);
INSERT INTO Commande VALUES(9, 10, '2026-05-12', 2);
INSERT INTO Commande VALUES(8, 5, '2026-08-01', 3);
INSERT INTO Commande VALUES(7, 8, '2026-03-19', 10);
INSERT INTO Commande VALUES(6, 4, '2026-11-07', 2);
INSERT INTO Commande VALUES(8, 1, '2026-06-25', 2);

''')

bd.close()